package com.system.demo.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.system.demo.entity.DTO.GraduationDate;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.time.LocalDate;

@Mapper
public interface GraduationDateMapper extends BaseMapper<GraduationDate> {

    // 根据年级前缀查询毕业日期
    @Select("SELECT graduation_date FROM graduation_date WHERE grade_prefix = #{gradePrefix}")
    LocalDate getGraduationDateByPrefix(String gradePrefix);
}
